import xlrd,sys,xdrlib




class Excle:
    def read_it(self,file_path,index=0):
        data=xlrd.open_workbook(file_path)
        sheet=data.sheets()[index]
        return sheet
if __name__=="__main__":
    s=Excle().read_it(r"C:\Users\Administrator\Desktop\testcase.xlsx")
    for i in range(1,2):#行数
        li=s.row_values(i)#获取一行的
        __import__("TS24.testcase."+li[1])
        m=sys.modules["TS24.testcase."+li[1]]
        obj=getattr(m,li[1])
        mtd=getattr(obj(),li[2])
        mtd(li)



    # print("")
    # for j in range(s.ncols):
    #     li2=s.col_values(j)[1:] #获取一列的值
    #     print(li2)

# print(help(xlrd.sheet))#查看xlrd下的所有方法